» The SUMIF Formula – Using Comparison Operators ( ) as Criteria
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
Example:
1. In cell E2, type the criterion 501.
2. In cell D2, insert the SUMIF formula shown in the Formula Bar.
Result:
The SUMIF formula returns only the total of cells B12:B17 because the value of cells A12 to A17 are 501.
Book Store:
Recommended Books:
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Writing Excel Macros with VBA, 2nd Edition
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Keys to Reading an Annual Report (Barron's Business Keys)
- Yes, You Can Time the Market!
- Business Plans Kit for Dummies (With CD-ROM)
No comments have been submitted.
